package script.db.groovy.hrds_prod_repo.nexus

databaseChangeLog(logicalFilePath: 'script/db/z_fix_table.groovy') {

    changeSet(author: 'wx', id: '2022-11-04-fix-table') {
       sql("""
           alter table rdupm_nexus_assets change created_by created_by bigint(20);
           alter table rdupm_nexus_assets change last_updated_by last_updated_by bigint(20);
           
           
           alter table rdupm_nexus_auth change created_by created_by bigint(20);
           alter table rdupm_nexus_auth change last_updated_by last_updated_by bigint(20);
           
           
           alter table rdupm_nexus_log change created_by created_by bigint(20);
           alter table rdupm_nexus_log change last_updated_by last_updated_by bigint(20);
           
           alter table rdupm_nexus_organization_service change created_by created_by bigint(20);
           alter table rdupm_nexus_organization_service change last_updated_by last_updated_by bigint(20);
           
           alter table rdupm_nexus_project_service change created_by created_by bigint(20);
           alter table rdupm_nexus_project_service change last_updated_by last_updated_by bigint(20);
           
           alter table rdupm_nexus_push change created_by created_by bigint(20);
           alter table rdupm_nexus_push change last_updated_by last_updated_by bigint(20);
           
           alter table rdupm_nexus_repository change created_by created_by bigint(20);
           alter table rdupm_nexus_repository change last_updated_by last_updated_by bigint(20);
           
           alter table rdupm_nexus_role change created_by created_by bigint(20);
           alter table rdupm_nexus_role change last_updated_by last_updated_by bigint(20);
           
           alter table rdupm_nexus_server_config change created_by created_by bigint(20);
           alter table rdupm_nexus_server_config change last_updated_by last_updated_by bigint(20);
           
           alter table rdupm_nexus_user change created_by created_by bigint(20);
           alter table rdupm_nexus_user change last_updated_by last_updated_by bigint(20);
       """)
    }
}